﻿using Dogshow.BusinessLogic.Utils;
using Dogshow.Model;
using DogshowRepository;

namespace Dogshow.Linq2SQLRepository
{
    public class DbInit : IDatabaseInitializer
    {
        public void Initialize()
        {
            using (var ctx = new DogshowModel())
            {
                if (!ctx.DatabaseExists())
                {
                    ctx.CreateDatabase();
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 1', 'PASTIRSKI PSI I PSI TERAČI STOKE(OSIM ŠVAJC. PASTIRSKIH PASA)')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 2', 'PINČERI I ŠNAUCERI, MOLOSI I ŠVAJCARSKI PASTIRSKI PSI')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 3', 'TERIJERI')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 4', 'JAZAVIČARI')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 5', 'ŠPIC TIP I PRIMITIVNI TIP PASA')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 6', 'GONIČI,TRAGAČI PO KRVI I SRODNE RASE')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 7', 'PTIČARI')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 8', 'RETRIVERI, CUNJAVCI I PSI ZA VODU')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 9', 'PSI ZA PRATNJU I RAZONODU')");
                    ctx.ExecuteCommand("INSERT INTO FCIGrupe VALUES ('FCI Grupa 10', 'HRTOVI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AIRESKI OVČAR', 1, 'CAO DA SERRA DE AIRES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ARDENSKI GOVEDAR', 1, 'BOUVIER DES ARDENNES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AUSTRALIJSKI ČUVAR STADA', 1, 'AUSTRALIAN KELPIE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AUSTRALIJSKI GOVEDAR', 1, 'AUSTRALIAN CATTLE DOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AUSTRALIJSKI OVČAR', 1, 'AUSTRALIAN SHEPHERD')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BELGIJSKI OVČAR', 1, 'CHIEN DE BERGER BELGE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BELI ŠVAJCARSKI OVČAR', 1, 'BERGER BLANC SUISSE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BERGAMSKI PASTIRSKI PAS', 1, 'CANE DA PASTORE BERGAMASCO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BOBTAIL', 1, 'OLD ENGLISH SHEEPDOG (BOBTAIL)')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BORDER KOLI', 1, 'BORDER COLLIE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BOSERON', 1, 'BERGER DE BEAUCE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BRADATI KOLI', 1, 'BEARDED COLLIE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BRIJEŠKI OVČAR', 1, 'BERGER DE BRIE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ČEŠKOSLOVAČKI VUČIJI PAS', 1, 'CESKOSLOVENSKY VLCAK')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FLANDRIJSKI GOVEDAR', 1, 'BOUVIER DES FLANDRES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOLANDSKI KOVRDŽAVI OVČAR', 1, 'SCHAPENDOES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOLANDSKI OVČAR', 1, 'HOLLANDSE HERDERSHOND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HRVATSKI OVČAR', 1, 'HRVATSKI OVČAR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JUŽNORUSKI OVČAR', 1, 'IOUJNOROUSSKAIA OVTCHARKA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KATALONSKI OVČAR', 1, 'PERRO DE PASTOR CATALAN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KOMONDOR', 1, 'KOMONDOR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KUVAS', 1, 'KUVASZ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MAJORŠKI OVČAR', 1, 'PERRO DE PASTOR MALLORQUIN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MAREMANO ABRUCEŠKI PASTIRSKI PAS', 1, 'CANE DA PASTORE MAREMMANO-ABRUZZESE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MUDI', 1, 'MUDI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI OVČAR', 1, 'DEUTSCHER SCHAEFERHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PAS SV. MIGUELA', 1, 'CAO FILA DE SAO MIGUEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PIKARDIJSKI OVČAR', 1, 'BERGER DE PICARD')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PIRINEJSKI OVČAR DUGE DLAKE', 1, 'BERGER DES PYRENEES A POIL LONG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PIRINEJSKI OVČAR KRATKE DLAKE', 1, 'BERGER DES PYRENEES A FACE RASE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PODHALANSKI OVČAR', 1, 'POLSKI OWCZAREK PODHALANSKY')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('POLJSKI RAVNIČARSKI OVČAR', 1, 'POLSKI OWCZAREK NIZINNY')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PULI', 1, 'PULI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PUMI', 1, 'PUMI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SARLOŠKI VUČIJI PAS', 1, 'SAARLOOS WOLFHOUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SLOVAČKI PASTIRSKI PAS', 1, 'SLOVENSKY CUVAC')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELŠKI KORGI KARDIGAN', 1, 'WELSH CORGI CARDIGAN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELŠKI KORGI PEMBROK', 1, 'WELSH CORGI PEMBROKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠETLANDSKI OVČAR', 1, 'SHETLAND SHEEPDOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠIPERKI', 1, 'SCHIPPERKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠKOTSKI OVČAR - DUGODLAKI', 1, 'COLLIE ROUGH')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠKOTSKI OVČAR - KRATKODLAKI', 1, 'COLLIE SMOOTH')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ALENTEJSKI PASTIRSKI PAS', 2, 'RAFEIRO DO ALENTEJO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ANADOLSKI PASTIRSKI PAS', 2, 'COBAN KOEPEGI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('APENCELSKI PASTIRSKI PAS', 2, 'APPENZELLER SENNENHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ARGENTINSKI PAS', 2, 'DOGO ARGENTINO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ATLASKI PASTIRSKI PAS', 2, 'AIDI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AUSTRIJSKI KRATKODLAKI PINČ', 2, 'OESTERREICHISCHER KURZHAARIGER PINSCHER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BERNARDINAC', 2, 'SAINT-BERNARD')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BERNSKI PASTIRSKI PAS', 2, 'BERNER SENNENHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BORDOŠKA DOGA', 2, 'DOGUE DE BORDEAUX')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BRAZILSKI PAS', 2, 'FILA BRASILEIRO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BUL MASTIF', 2, 'BULLMASTIFF')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BULDOG', 2, 'BULLDOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('CRNI TERIJER', 2, 'TCHIORNY TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DANSKI PAS', 2, 'BROHOLMER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DOBERMAN', 2, 'DOBERMANN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ENTLEBUŠKI PASTIRSKI PAS', 2, 'ENTLEBUCHER SENNENHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ESTRELSKI PASTIRSKI PAS', 2, 'CAO DA SERRA DA ESTRELA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOLANDSKI PINČ', 2, 'HOLLANDSE SMOUSHOND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOVAVART', 2, 'HOVAWART')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JAPANSKI BORAC', 2, 'TOSA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JUGOSLOVENSKI OVČARSKI PAS-ŠARPLANINAC', 2, 'JUGOSLOVENSKI OVČARSKI PAS-ŠARPLANINAC')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KANARSKI PAS', 2, 'DOGO CANARIO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KANE KORSO', 2, 'CANE CORSO ITALIANO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KAVKASKI OVČAR', 2, 'KAVKAZSKAIA OVTCHARKA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KRAŠKI OVČAR', 2, 'KRAŠKI OVČAR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LANDSIR', 2, 'LANDSEER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LEONBERGER', 2, 'LEONBERGER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MAJMUNSKI PINČ', 2, 'AFFENPINSCHER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MAJORŠKI ČUVAR', 2, 'PERRO DOGO MALLORQUIN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MASTIF', 2, 'MASTIFF')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NAPULJSKI MASTIF', 2, 'MASTINO NAPOLETANO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKA DOGA', 2, 'DEUTSCHE DOGGE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI BOKSER', 2, 'DEUTSCHER BOXER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NJUFAUNDLANDSKI PAS', 2, 'NEWFOUNDLAND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PASTIRSKI PAS IZ LABOREIRA', 2, 'CAO DE CASTRO LABOREIRO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PATULJASTI PINČ', 2, 'ZWERGPINSCHER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PATULJASTI ŠNAUCER', 2, 'ZWERGSCHNAUZER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PINČ', 2, 'DEUTSCHE PINSCHER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PIRINEJSKI MASTIF', 2, 'MASTIN DE LOS PIRINEOS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PIRINEJSKI PLANINSKI PAS', 2, 'CHIEN DE MONTAGNE DES PYRENEES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ROTVAJLER', 2, 'ROTTWEILER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SREDNJEAZIJSKI OVČAR', 2, 'SREDNEASIATSKAIA OVTCHARKA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SREDNJI ŠNAUCER', 2, 'SCHNAUZER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('TIBETSKI MASTIF', 2, 'TIBETAN MASTIFF')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI JAPANSKI PAS', 2, 'GREAT JAPANESE DOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI ŠNAUCER', 2, 'RIESENSCHNAUZER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI ŠVAJCARSKI PASTIRSKI PAS', 2, 'GROSER SCHWEIZERSENNENHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠAR - PEJ', 2, 'SHAR PEI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠPANSKI MASTIF', 2, 'MASTIN ESPANOL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AMERIČKI STAFORDSKI TERIJER', 3, 'AMERICAN STAFFORDSHIRE TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AUSTRALIJSKI TERIJER', 3, 'AUSTRALIAN TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BEDLINGTON TERIJER', 3, 'BEDLINGTON TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BORDER TERIJER', 3, 'BORDER TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BRAZILSKI TERIJER', 3, 'TERRIER BRASILEIRO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BUL TERIJER', 3, 'ENGLISH BULL TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DANDI DINMONT TERIJER', 3, 'DANDIE DINMONT TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DŽEK RASELOV TERIJER', 3, 'JACK RUSSEL TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ČEŠKI TERIJER', 3, 'ČESKY TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ENGLESKI PATULJASTI TERIJER', 3, 'TOY TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ERDEL TERIJER', 3, 'AIREDALE TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FOKSTERIJER KRATKODLAKI', 3, 'FOX TERRIER-SMOOTH')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FOKSTERIJER OŠTRODLAKI', 3, 'FOX TERRIER-WIRE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IMALSKI TERIJER', 3, 'IRISH GLEN OF IMAAL TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IRSKI TERIJER', 3, 'IRISH TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JAPANSKI TERIJER', 3, 'NIHON TERIA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JORKŠIRSKI TERIJER', 3, 'YORKSHIRE TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KERI BLU TERIJER', 3, 'KERRY BLUE TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KERN TERIJER', 3, 'CAIRN TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LEJKLANDSKI TERIJER', 3, 'LAKELAND TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MANČESTER TERIJER', 3, 'MANCHESTER TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MEKODLAKI PŠENIČNO ŽUTI TERIJER', 3, 'SOFT-COATED WHEATEN TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI LOVAČKI TERIJER', 3, 'DEUTSCHER JAGDTERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORFOLŠKI TERIJER', 3, 'NORFOLK TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORVIČKI TERIJER', 3, 'NORWICH TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PARSON RASELOV TERIJER', 3, 'PARSON RUSSELL TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SILIHEM TERIJER', 3, 'SEALYHAM TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SILKI TERIJER', 3, 'AUSTRALIAN SILKY TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SKAJ TERIJER', 3, 'SKYE TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('STAFORDSKI BUL TERIJER', 3, 'STAFFORDSHIRE BULL TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELŠKI TERIJER', 3, 'WELSH TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ZAPADNO ŠKOTSKI BELI TERIJER', 3, 'WEST HIGHLAND WHITE TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠKOTSKI TERIJER', 3, 'SCOTTISH TERRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JAZAVIČAR', 4, 'DACHSHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AKITA', 5, 'AKITA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ALJASKI MALAMUT', 5, 'ALASKAN MALAMUTE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BASENJI', 5, 'BASENJI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ČAU-ČAU', 5, 'CHOW-CHOW')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('EURASIER', 5, 'EURASIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FARAONSKI PAS', 5, 'CHIEN DU PHARAON')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FINSKI ŠPIC', 5, 'SUOMENPYSTYKORVA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('GRENLANDSKI PAS', 5, 'GRONLANDSHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOKAIDO', 5, 'HOKKAIDO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IBIZKI HRT', 5, 'PODENCO IBICENCO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ISLANDSKI OVČAR', 5, 'ICELAND DOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ISTOČNO SIBIRSKA LAJKA', 5, 'LAIKA WASTATCHNO-SIBIRSKAIA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ITALIJANSKI VOLPINO', 5, 'VOLPINO ITALIANO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IZRAELSKI OVČAR', 5, 'CANAAN DOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JAPANSKI ŠPIC', 5, 'SPITZ JAPONAIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('JEMTLANDSKI PAS', 5, 'JAMTHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KAI', 5, 'KAI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KANARSKI HRT', 5, 'PODENCO CANARIO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KARELIJSKI GONIČ MEDVEDA', 5, 'KARJALANKARHUKOIRA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KIŠU', 5, 'KISHU')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KOREA JINDO DOG', 5, 'KOREA JINDO DOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LAPONSKI PAS', 5, 'SVENSK LAPPHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LAPONSKI PASTIRSKI PAS', 5, 'LAPINPOROKOIRA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LAPONSKI ŠPIC', 5, 'SUOMENLAPINKOIRA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MEKSIČKI GOLOKOŽI PAS', 5, 'XOLOITZQUINTLE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI ŠPIC', 5, 'DEUTSCHER SPITZ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORBOTENSKI ŠPIC', 5, 'NORBOTTENSPETS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORVEŠKI CRNI GONIČ', 5, 'NORSK ELGHUND SORT')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORVEŠKI LOVAČKI ŠPIC', 5, 'NORSK LUNDENHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORVEŠKI SIVI GONIČ', 5, 'NORSK ELGHUND GRA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NORVEŠKI ŠPIC', 5, 'NORSK BUHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PERUANSKI INKA PAS', 5, 'PERRO SIN PELO DEL PERU')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PORTUGALSKI HRT', 5, 'PODENGO PORTUGUES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('RUSKO EVROPSKA LAJKA', 5, 'LAIKA RUSSKO-EVROPEISKAIA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SAMOJED', 5, 'SAMOYED')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SIBIRSKI HASKI', 5, 'SIBERIAN HUSKY')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SICILIJANSKI HRT', 5, 'CIRNECO DELL ETNA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('TAJLANDSKI RIDŽBEK', 5, 'THAI RIDGEBACK DOG')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ZAPADNO SIBIRSKA LAJKA', 5, 'LAIKA ZAPADNO SIBIRSKAIA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠIBA', 5, 'SHIBA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠIKOKU', 5, 'SHIKOKU')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠVEDSKI PASTIRSKI PAS', 5, 'VASTGOTASPETS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ALPSKI BRAK JAZAVIČAR', 6, 'ALPENLANDISCHE DACHSBRACKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AMERIČKI LISIČAR', 6, 'AMERICAN FOXHOUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ARIEŠKI GONIČ', 6, 'ARIEGEOIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ARTEZIJSKO NORMANSKI BASET', 6, 'BASSET ARTESIEN NORMAND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ARTOAŠKI GONIČ', 6, 'CHIEN D ARTOIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AUSTRIJSKI RAVNODLAKI GONIČ', 6, 'OSTERREICHISCHE GLATTHAARIGE BRACKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BASET', 6, 'BASSET HOUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BAVARSKI PLANINSKI KRVOSLEDNIK', 6, 'BAYRISCHER GEBIRGSSCHWEISSHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BIGL ZEČAR', 6, 'BEAGLE HARRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BILI', 6, 'BILLY')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BOSANSKI OŠTRODLAKI GONIČ-BARAK', 6, 'BOSANSKI OŠTRODLAKI GONIČ-BARAK')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BRETANJSKI RIĐI BASET', 6, 'BASSET FAUVE DE BRETAGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DALMATINSKI PAS', 6, 'DALMATINAC')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DUNKEROV GONIČ', 6, 'DUNKER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ENGLESKI LISIČAR', 6, 'FOXHOUND (ENGLISH)')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ERDELJSKI GONIČ', 6, 'ERDELYI KOPO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FINSKI GONIČ', 6, 'SUOMENAJOKOIRA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRANCUSKI TROBOJNI GONIČ', 6, 'FRANCAIS TRICOLORE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRANCUSKO BELO CRNI GONIČ', 6, 'FRANCAIS BLANC ET NOIR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRANCUSKO BELO ORANŽ GONIČ', 6, 'FRANCAIS BLANC ET ORANGE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('GONIČ RAKUNA', 6, 'BLACK AND TAN COONHUOUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('GRČKI GONIČ', 6, 'HELLINIKOS ICHNILATIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HAMILTONOV GONIČ', 6, 'HAMILTON STOVARE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HANOVERSKI KRVOSLEDNIK', 6, 'HANNOVERISCHER SCHWEISSHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HARIJER', 6, 'HARRIER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HIGENOV GONIČ', 6, 'HYGENHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOLDENSKI GONIČ', 6, 'HALDENSTOVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ISTARSKI KRATKODLAKI GONIČ', 6, 'ISTARSKI KRATKODLAKI GONIČ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ISTARSKI OŠTRODLAKI GONIČ', 6, 'ISTARSKI OŠTRODLAKI GONIČ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ITALIJANSKI GONIČ - kratkodlaki', 6, 'SEGUGIO ITALIANO - A PELO RASO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ITALIJANSKI GONIČ - oštrodlaki', 6, 'SEGUGIO ITALIANO A PELO FORTE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MALI ENGLESKO FRANCUSKI MAT GONIČ', 6, 'ANGLO FRANCAIS DE PETITE VENERIE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MALI GASKONJSKO SENTANŽUJSKI GONIČ', 6, 'PETIT GASCON SAINTONGEOIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MALI OŠTRODLAKI VENDEJSKI BASET', 6, 'PETIT BASSET GRIFFON VENDEEN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MALI PLAVI GASKONJSKI GONIČ', 6, 'PETIT BLEU DE GASCOGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI GONIČ', 6, 'DEUTSCHE BRACKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NIVERNEJSKI OŠTRODLAKI GONIČ', 6, 'GRIFFON NIVERNAIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PAS SVETOG HUBERTA - BLODHUND', 6, 'CHIEN DE SAINT HUBERT')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PLANINSKI GONIČ', 6, 'PLANINSKI GONIČ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PLAVI GASKONJSKI GONIČ', 6, 'BASSET BLEU DE GASCOGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PLAVI OŠTRODLAKI GASKONJSKI GONIČ', 6, 'GRIFFON BLEU DE GASCOGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('POATUŠKI GONIČ', 6, 'POITEVIN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('POLJSKI GONIČ', 6, 'OGAR POLSKI')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PORCULANSKI GONIČ', 6, 'PORCELAINE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('POSAVSKI GONIČ', 6, 'POSAVSKI GONIČ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('RIĐI OŠTRODLAKI BRETANJSKI GONIČ', 6, 'GRIFFON FAUVE DE BRETAGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('RODEZIJSKI RIDŽBEK', 6, 'RHODESIAN RIDGEBACK')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SLOVAČKI GONIČ', 6, 'SLOVENSKY KOPOV')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SMOLONDSKI GONIČ', 6, 'SMALANDSSTOVARE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SRPSKI GONIČ', 6, 'SERBSKI GONIČ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SRPSKI TROBOJNI GONIČ', 6, 'SRPSKI TROBOJNI GONIČ')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('TIROLSKI GONIČ', 6, 'TIROLER BRACKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI ENGL.-FRANC.BELO ORANŽ GONIČ', 6, 'GRAND ANGLO-FRANCAIS BLANC ET ORANGE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI ENGLESKO FRANCUSKI GONIČ', 6, 'GRAND ANGLO-FRANCAIS TRICOLORE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI ENGLESKO-FRANC.BELO CRNI GONIČ', 6, 'GRAND ANGLO-FRANCE BLANC ET NOIR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI GASKONJSKO SENTANŽUJSKI GONIČ', 6, 'GRAND GASCON SAINTONGEOIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI OŠTRODLAKI VENDEJSKI BASET', 6, 'GRAND BASSET GRIFFON VENDEN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI PLAVI GASKONJSKI GONIČ', 6, 'GRAND BLEU DE GASCOGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI VENDEJSKI GRIFON', 6, 'GRAND GRIFFON VENDEEN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VENDEJSKI OŠTRODLAKI GONIČ', 6, 'BRIQUET GRIFFON VENDEEN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VESTFALSKI BRAK JAZAVIČAR', 6, 'WESTFALISCHE DACHSBRACKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VIDRAŠ', 6, 'OTTERHOUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠILEROV GONIČ', 6, 'SCHILLER STOVARE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠPANSKI BRDSKI GONIČ', 6, 'SABUESO ESPANOL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠTAJERSKI OŠTRODLAKI VISOKOBRDSKI GONIČ', 6, 'STEIRISCHE RAUHHAARIGE HOCHGEBIRGSBRACKE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠVAJCARSKI GONIČ', 6, 'SCHWEIZERISCHE LAUFHUNDE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠVAJCARSKI NISKONOGI GONIČ', 6, 'SCHWEIZERISCHE NIEDERLAUFHUNDE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠVEDSKI GONIČ DREVER', 6, 'DREVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ARIJEŠKI PTIČAR', 7, 'BRAQUE DE L ARIEGE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BURBONSKI PTIČAR', 7, 'BRAQUE DU BOURBONNAIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BURGOŠKI JAREBIČAR', 7, 'PERDIGUERO DE BURGOS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('DRENTSKI PTIČAR', 7, 'DRENTSCHE PATRIJSHOND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ČEŠKI FOUSEK', 7, 'ČESKY FOUSEK')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ENGLESKI SETER', 7, 'ENGLISH SETTER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('EPANJEL BRETON', 7, 'EPAGNEUL BRETON')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRANCUSKI EPANJEL', 7, 'EPAGNEUL FRANCAIS')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRANCUSKI PTIČAR GASKONJSKI TIP', 7, 'BRAQUE FRANCAIS TYPE GASCOGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRANCUSKI PTIČAR PIRINEJSKI TIP', 7, 'BRAQUE FRANCAIS TYPE PYRENEES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('GORDON SETER', 7, 'GORDON SETTER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('HOLANDSKI PREPELIČAR', 7, 'STABYHOUN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IRSKI CRVENI SETER', 7, 'IRISH RED SETTER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IRSKI CRVENO-BELI SETER', 7, 'IRISH RED AND WHITE SETTER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ITALIJANSKI KRATKODLAKI PTIČAR', 7, 'BRACCO ITALIANO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ITALIJANSKI SPINON', 7, 'SPINONE ITALIANO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KORTHALSOV GRIFON', 7, 'GRIFFON D ARRET A POIL DUR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MAĐARSKA VIŽLA KRATKODLAKA', 7, 'ROVIDSZORU MAGYAR VIZSLA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MAĐARSKA VIŽLA OŠTRODLAKA', 7, 'DROTZORU MAGYAR VIZSLA')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MALI MINSTERLENDER', 7, 'KLEINER MUNSTERLANDER VORSTEHHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI DUGODLAKI PTIČAR', 7, 'DEUTSCH LANGHAAR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI KOSTRETASTI PTIČAR', 7, 'STICHELHAARIGER DEUTSCHER VORSTEHHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI KRATKODLAKI PTIČAR', 7, 'DEUTSCH KURZHAAR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI OŠTRODLAKI PTIČAR', 7, 'DEUTSCH DRATHAAR')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('OVERNEJSKI PTIČAR', 7, 'BRAQUE D AUVERGNE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PIKARDIJSKI EPANJEL', 7, 'EPAGNEUL PICARD')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PLAVI PIKARDIJSKI EPANJEL', 7, 'EPAGNEUL BLUE DE PICARDIE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('POENTER', 7, 'ENGLISH POINTER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PONT-ODMERŠKI EPANJEL', 7, 'EPAGNEUL DE PONT-AUDEMER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PORTUGALSKI JAREBIČAR', 7, 'PERDIGUEIRO PORTUGUES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PUDLPOENTER', 7, 'PUDELPOINTER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SENŽERMENSKI PTIČAR', 7, 'BRAQUE SAINT-GERMAIN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SLOVAČKI OŠTRODLAKI PTIČAR', 7, 'SLOVENSKY HRUBOSRSTY STAVAČ (OHAR)')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('STARI DANSKI PTIČAR', 7, 'GAMMEL DANSK HONSEHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VAJMARSKI PTIČAR', 7, 'WEIMARANER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELIKI MINSTERLENDSKI PTIČAR', 7, 'GROSSER MUNSTERLANDER VORSTEHHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AMERIČKI KOKER ŠPANIJEL', 8, 'AMERICAN COCKER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('AMERIČKI ŠPANIJEL ZA VODU', 8, 'AMERICAN WATER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('BARBE', 8, 'BARBET')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ČIZOPIK RETRIVER', 8, 'CHESAPEAKE BAY RETRIEVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ENGLESKI KOKER ŠPANIJEL', 8, 'ENGLISH COCKER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ENGLESKI ŠPRINGER ŠPANIJEL', 8, 'ENGLISH SPRINGER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('FRIZIJSKI ŠPANIJEL', 8, 'WETTERHOUN')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('IRSKI ŠPANIJEL ZA VODU', 8, 'IRISH WATER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('KLAMBER ŠPANIJEL', 8, 'CLUMBER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LABRADOR RETRIVER', 8, 'LABRADOR RETRIEVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('LAGOTO ROMANJOLO', 8, 'LAGOTTO ROMAGNOLO')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('MALI HOLANDSKI PAS ZA LOV PTICA NA VODI', 8, 'KOOIKERHONDJE')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('NEMAČKI PREPELIČAR', 8, 'DEUTSCHER WACHTELHUND')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('POLJSKI ŠPANIJEL', 8, 'FIELD SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('PORTUGALSKI PAS ZA VODU', 8, 'CAO DE AGUA PORTUGUES')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('RAVNODLAKI RETRIVER', 8, 'FLAT-COATED RETRIEVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('RETRIVER KOVRDŽAVE DLAKE', 8, 'CURLY-COATED RETRIEVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('SASEKS ŠPANIJEL', 8, 'SUSSEX SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('TOLING RETRIVER', 8, 'NOVA SCOTIA DUCK TOLLING RETRIEVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('VELŠKI ŠPRINGER ŠPANIJEL', 8, 'WELSH SPRINGER SPANIEL')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ZLATNI RETRIVER', 8, 'GOLDEN RETRIEVER')");
                    ctx.ExecuteCommand("INSERT INTO RasePasa VALUES ('ŠPANSKI PAS ZA VODU', 8, 'PERRO DE AGUA ESPANOL')");


                    ctx.ExecuteCommand("INSERT INTO Titule VALUES('C.A.C.I.B')");
                    ctx.ExecuteCommand("INSERT INTO Titule VALUES(' Res C.A.C.I.B')");
                    ctx.ExecuteCommand("INSERT INTO Titule VALUES('C.A.C')");
                    ctx.ExecuteCommand("INSERT INTO Titule VALUES('Res C.A.C')");

                    var korisniciRepository = new KorisniciRepository();
                    korisniciRepository.Sacuvaj(new Korisnik()
                    {
                        Aktivan = true,
                        Email = "zeljko.bajsanski@gmail.com",
                        KorisnickoIme = "jovana.bajsanski",
                        Naziv = "Master",
                        VrstaKorisnika = 1,
                        Lozinka = new Md5Encryptor().Encrypt("vv")
                    });
                }
            }
        }
    }
}